﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace YiSha.Util
{
    /// <summary>
    ///  EPPlus帮助类
    /// </summary>
    public class EPPlusHelper
    {
        /// <summary>
        /// 读取合并的Excel单元格
        /// </summary>
        /// <param name="wSheet">excel Sheet</param>
        /// <param name="row">当前行</param>
        /// <param name="column">当前列</param>
        /// <returns></returns>
        //public static string GetMegerValue(ExcelWorksheet wSheet, int row, int column)
        //{
        //    string range = wSheet.MergedCells[row, column];
        //    if (range == null)
        //        if (wSheet.Cells[row, column].Value != null)
        //            return wSheet.Cells[row, column].Value.ToString();
        //        else
        //            return "";
        //    object value =
        //        wSheet.Cells[(new ExcelAddress(range)).Start.Row, (new ExcelAddress(range)).Start.Column].Value;
        //    if (value != null)
        //        return value.ToString();
        //    else
        //        return "";
        //}
    }
}
